#!/usr/bin/env python
# -*- coding:utf-8 -*-
# Author Jmz

import pymysql

conn = pymysql.connect(host="localhost",port=3306,database="db1",username="root")

cursor = conn.cursor(pymysql.cursors.DictCursor) # 字典类型

rows = cursor.execute('insert into member values(%s)',('jmz'))

res = cursor.fetchall()


print(res)

cursor.close()

conn.close()

